/*
	Generate "Alter Login" scripts to reset all users passwords to 'welcome'
*/

select 'ALTER LOGIN [' + name + '] WITH PASSWORD=''welcome'', CHECK_POLICY=OFF' 
from sys.sysusers
where 
	issqlrole = 0 
	and islogin = 1
	and not name in ('public', 'dbo', 'guest', 'INFORMATION_SCHEMA', 'sys')